
/// 用户数据库表结构
class UserTableStruct {

  /// 表名
  static const String tableName = 'tb_user';

  /// 字段名常量
  static const String colId = 'id';
  static const String colAdmin = 'admin';
  static const String colChapterTops = 'chapterTops';
  static const String colCoinCount = 'coinCount';
  static const String colCollectIds = 'collectIds';
  static const String colEmail = 'email';
  static const String colIcon = 'icon';
  static const String colNickname = 'nickname';
  static const String colPassword = 'password';
  static const String colPublicName = 'publicName';
  static const String colToken = 'token';
  static const String colUsername = 'username';

  /// 建表语句
  static const String createTableSql = '''
    CREATE TABLE $tableName (
      $colId INTEGER PRIMARY KEY,
      $colAdmin INTEGER NOT NULL,
      $colChapterTops TEXT,
      $colCoinCount INTEGER,
      $colCollectIds TEXT,
      $colEmail TEXT,
      $colIcon TEXT,
      $colNickname TEXT,
      $colPassword TEXT,
      $colPublicName TEXT,
      $colToken TEXT,
      $colUsername TEXT
    )
  ''';

}